SGI Freeware 1999 August/SGI Freeware 1999 August.iso/dist/fw_gnats.idb/usr/freeware/lib/gnats/contrib/sql/statesumm.sql.z/statesumm.sql

Text File | 1999-04-16 | 241 b | 13 lines

select statenum, statestr, count(*)
  from gnats, statecode
  where gnatsstate=statenum and
        gnatsclass < 5
  group by statestr, statenum
  order by statenum;

select " ", "Total", count(*)
  from gnats
  where
       gnatsclass <5;